{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Flexi individual","Flexi Floater","Unit","Dr Pankaj","ipa","Summary"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":1,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Flexi individual","index":0,"n_rows":47,"n_cols":36,"rows_kept":47,"cut":false,"hidden":true,"merged":[[16,6,16,9],[19,5,19,9],[23,6,23,9],[27,6,27,9],[25,6,25,9],[26,6,26,9],[42,6,42,9],[43,6,43,9],[44,6,44,9],[40,6,40,9],[46,6,46,9],[45,6,45,9],[28,12,28,15],[29,12,29,15],[32,12,32,15],[33,12,33,15],[36,5,36,9],[28,6,28,9],[29,6,29,9],[32,6,32,9],[33,6,33,9],[30,12,30,15],[31,12,31,15],[30,6,30,9],[31,6,31,9],[19,11,19,15],[23,12,23,15],[25,12,25,15],[26,12,26,15],[27,12,27,15],[6,6,6,9],[10,6,10,9],[11,6,11,9],[12,6,12,9],[15,6,15,9],[13,6,13,9],[14,6,14,9]]}
[]
[]
[null,null,"Master",null,null,"Flexi Indiviudal - Insured Level",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,"Member",1,2,3,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,"Premium"]
[null,null,null,null,null,"Policy Tenure",1]
[null,null,null,null,null,"Basic Premium",{"$f":"$G$7*G6","v":0},{"$f":"$G$7*H6","v":0},{"$f":"$G$7*I6","v":0},0]
[null,null,null,null,null,"Loading %"]
[null,null,null,null,null,"Loaded Basic Premium",{"$f":"(G8*G9%)+G8","v":0},{"$f":"(H8*H9%)+H8","v":0},0,{"$f":"(J8*J9%)+J8","v":0}]
[null,null,null,null,null,"Sum of the Premium",{"$f":"SUM(G10:J10)","v":0}]
[null,null,null,null,null,"Discount %"]
[null,null,null,null,null,"Discounted Premium",{"$f":"G11-(G12%*G11)","v":0}]
[null,null,null,null,null,"Longterm Discount",{"$f":"IF(G7=1,0,IF(G7=2,8,IF(G7=3,15,0)))","v":0}]
[null,null,null,null,null,"Longterm Discounted Premium",{"$f":"G13-(G14%*G13)","v":0}]
[null,null,null,null,null,"Service Tax",{"$f":"12.36%*G15","v":0}]
[null,null,null,null,null,"Total Premium",{"$f":"G16+G15","v":0}]
[]
[]
[null,null,null,null,null,"Flexi Indiviudal - Policy Level (when Total discount > Total Loading)",null,null,null,null,null,"Flexi Indiviudal - Policy Level (when Total discount < Total Loading)"]
[]
[null,null,null,null,null,"Member",1,2,3,4,null,"Member",1,2,3,4]
[null,null,null,null,null,"Premium",null,null,null,null,null,"Premium"]
[null,null,null,null,null,"Policy Tenure",1,null,null,null,null,"Policy Tenure",1]
[null,null,null,null,null,"Basic Premium",{"$f":"$G$7*G23","v":0},{"$f":"$G$7*H23","v":0},{"$f":"$G$7*I23","v":0},0,null,"Basic Premium",{"$f":"$G$7*M23","v":0},{"$f":"$G$7*N23","v":0},{"$f":"$G$7*O23","v":0},0]
[null,null,null,null,null,"Sum of Premiums",{"$f":"SUM(G25:J25)","v":0},null,null,null,null,"Sum of Premiums",{"$f":"SUM(M25:P25)","v":0}]
[null,null,null,null,null,"Total Loading %",null,null,null,null,null,"Total Loading %"]
[null,null,null,null,null,"Total Discount %",null,null,null,null,null,"Total Discount %"]
[null,null,null,null,null,"Nulified",{"$f":"G28-G27","v":0},null,null,null,null,"Nulified",{"$f":"M27-M28","v":0}]
[null,null,null,null,null,"Discounted Premium",{"$f":"G26-(G29%*G26)","v":0},null,null,null,null,"Loaded Premium",{"$f":"M26+(M29%*M26)","v":0}]
[null,null,null,null,null,"Longterm Discount",{"$f":"IF(G24=1,0,IF(G24=2,8,IF(G24=3,15,0)))","v":0},null,null,null,null,"Longterm Discount",{"$f":"IF(M24=1,0,IF(M24=2,8,IF(M24=3,15,0)))","v":0}]
[null,null,null,null,null,"Longterm Discounted Premium",{"$f":"G30-(G31%*G30)","v":0},null,null,null,null,"Longterm Discounted Premium",{"$f":"M30-(M31%*M30)","v":0}]
[null,null,null,null,null,"Service Tax",{"$f":"12.36%*G32","v":0},null,null,null,null,"Service Tax",{"$f":"12.36%*M32","v":0}]
[null,null,null,null,null,"Total Premium",{"$f":"G33+G32","v":0},null,null,null,null,"Total Premium",{"$f":"M33+M32","v":0}]
[]
[]
[null,null,null,null,null,"Flexi Indiviudal - Policy Level (when Total discount = Total Loading)"]
[]
[null,null,null,null,null,"Member",1,2,3,4]
[null,null,null,null,null,"Premium"]
[null,null,null,null,null,"Policy Tenure",1]
[null,null,null,null,null,"Basic Premium",{"$f":"$G$7*G40","v":0},{"$f":"$G$7*H40","v":0},{"$f":"$G$7*I40","v":0},0]
[null,null,null,null,null,"Sum of Premiums",{"$f":"SUM(G42:J42)","v":0}]
[null,null,null,null,null,"Longterm Discount",{"$f":"IF(G41=1,0,IF(G41=2,8,IF(G41=3,15,0)))","v":0}]
[null,null,null,null,null,"Longterm Discounted Premium",{"$f":"G43-(G44%*G43)","v":0}]
[null,null,null,null,null,"Service Tax",{"$f":"12.36%*G45","v":0}]
[null,null,null,null,null,"Total Premium",{"$f":"G46+G45","v":0}]

{"sheet":"Flexi Floater","index":1,"n_rows":49,"n_cols":30,"rows_kept":49,"cut":false,"hidden":true,"merged":[[33,4,33,7],[20,4,20,7]]}
["Type of family","Loading on primary Insured premium",null,null,"Master",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["1+1 (Non – Earning)",0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["1+1 (Earning)",0.45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
["1+1 (Child)",7.0000000000000007E-2,null,null,"Flexi Family floater - Policy Level (when Total discount > Total Loading)",null,null,null,null,null,"Flexi Family floater - Policy Level (when Total discount < Total Loading)"]
["1+2 (Non - Earning +Child)",0.3]
["1+2 (Earning + Child)",0.55000000000000004,null,null,"Member","Primary Insured",null,null,null,null,"Member","Primary Insured"]
["1+2 (Children)",0.2,null,null,"Premium",null,null,null,null,null,"Premium"]
["1+3 (Non - Earning +2 Children)",0.45,null,null,"Policy Tenure",1,null,null,null,null,"Policy Tenure",1]
["1+3 (Earning +2 Children)",0.66,null,null,"Basic Premium",{"$f":"F8*F7","v":0},null,null,null,null,"Basic Premium",{"$f":"L8*L7","v":0}]
[null,null,null,null,"Family Floater Loading %",null,null,null,null,null,"Family Floater Loading %"]
[null,null,null,null,"Loaded Premium",{"$f":"(F10%*F9)+F9","v":0},null,null,null,null,"Loaded Premium",{"$f":"(L10%*L9)+L9","v":0}]
[null,null,null,null,"Total Loading",null,null,null,null,null,"Total Loading"]
[null,null,null,null,"Total Discount",null,null,null,null,null,"Total Discount"]
[null,null,null,null,"Nulifed ",{"$f":"F13-F12","v":0},null,null,null,null,"Nulifed ",{"$f":"L12-L13","v":0}]
[null,null,null,null,"Discounted Premium",{"$f":"F11-(F14%*F11)","v":0},null,null,null,null,"Loaded Premium",{"$f":"L11+(L14%*L11)","v":0}]
[null,null,null,null,"Longterm Discount",{"$f":"IF(F8=1,0,IF(F8=2,8,IF(F8=3,15,0)))","v":0},null,null,null,null,"Longterm Discount",{"$f":"IF(L8=1,0,IF(L8=2,8,IF(L8=3,15,0)))","v":0}]
[null,null,null,null,"Longterm Discounted Premium",{"$f":"F15-(F16%*F15)","v":0},null,null,null,null,"Longterm Discounted Premium",{"$f":"L15-(L16%*L15)","v":0}]
[null,null,null,null,"Service Tax",{"$f":"12.36%*F17","v":0},null,null,null,null,"Service Tax",{"$f":"12.36%*L17","v":0}]
[null,null,null,null,"Total Premium",{"$f":"F18+F17","v":0},null,null,null,null,"Total Premium",{"$f":"L18+L17","v":0}]
[]
[null,null,null,null,"Flexi Family floater - Policy Level (when Total discount =Total Loading)"]
[]
[null,null,null,null,"Member","Primary Insured"]
[null,null,null,null,"Premium"]
[null,null,null,null,"Policy Tenure",1]
[null,null,null,null,"Basic Premium",{"$f":"F25*F24","v":0}]
[null,null,null,null,"Family Floater Loading %"]
[null,null,null,null,"Loaded Premium",{"$f":"(F27%*F26)+F26","v":0}]
[null,null,null,null,"Longterm Discount",{"$f":"IF(F25=1,0,IF(F25=2,8,IF(F25=3,15,0)))","v":0}]
[null,null,null,null,"Longterm Discounted Premium",{"$f":"F28-(F29%*F28)","v":0}]
[null,null,null,null,"Service Tax",{"$f":"12.36%*F30","v":0}]
[null,null,null,null,"Total Premium",{"$f":"F31+F30","v":0}]
[]
[null,null,null,null,"Flexi Family floater - Insured level"]
[]
[null,null,null,null,"Member","Primary Insured"]
[null,null,null,null,"Premium"]
[null,null,null,null,"Policy Tenure",1]
[null,null,null,null,"Basic Premium",{"$f":"F38*F37","v":0}]
[null,null,null,null,"Family Floater Loading %"]
[null,null,null,null,"Loaded Premium",{"$f":"(F40%*F39)+F39","v":0}]
[null,null,null,null,"Loading %"]
[null,null,null,null,"Loaded Basic Premium",{"$f":"(F41*F42%)+F41","v":0}]
[null,null,null,null,"Discount %"]
[null,null,null,null,"Discounted Premium",{"$f":"F43-(F44%*F43)","v":0}]
[null,null,null,null,"Longterm Discount",{"$f":"IF(F38=1,0,IF(F38=2,8,IF(F38=3,15,0)))","v":0}]
[null,null,null,null,"Longterm Discounted Premium",{"$f":"F45-(F46%*F45)","v":0}]
[null,null,null,null,"Service Tax",{"$f":"12.36%*F47","v":0}]
[null,null,null,null,"Total Premium",{"$f":"F48+F47","v":0}]

{"sheet":"Unit","index":2,"n_rows":53,"n_cols":40,"rows_kept":53,"cut":false,"hidden":true,"merged":[[52,6,52,9],[5,6,5,9],[5,12,5,14],[24,6,24,9],[24,12,24,15],[43,6,43,9],[40,5,40,9],[46,6,46,9],[48,6,48,9],[49,6,49,9],[50,6,50,9],[51,6,51,9],[35,6,35,9],[35,12,35,15],[36,6,36,9],[36,12,36,15],[37,6,37,9],[37,12,37,15],[32,6,32,9],[32,12,32,15],[33,6,33,9],[33,12,33,15],[34,6,34,9],[34,12,34,15],[29,6,29,9],[29,12,29,15],[30,6,30,9],[30,12,30,15],[31,6,31,9],[31,12,31,15],[17,6,17,9],[18,6,18,9],[21,5,21,9],[21,11,21,15],[27,6,27,9],[27,12,27,15],[16,6,16,9],[8,6,8,9],[12,6,12,9],[13,6,13,9],[14,6,14,9],[15,6,15,9]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,"Select","Select","I"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,"Basic","Yes","II"]
[null,null,null,null,null,"Unit - Insured Level",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,"Wide","No","III"]
[null,null,"Master",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comprehensive"]
[null,null,null,null,null,"Member",1,2,3,4]
[null,null,null,null,null,"Plan Type","Select",null,null,null,null,null,"Net Premium"]
[null,null,null,null,null,"Risk Category","I","I","I","I"]
[null,null,null,null,null,"Premium",null,null,null,null,null,null,"Risk I","Risk II","Risk III"]
[null,null,null,null,null,"Policy Tenure",1,null,null,null,null,"Basic",703,857,1165]
[null,null,null,null,null,"Basic Premium",{"$f":"$G$9*G8","v":0},{"$f":"$G$9*H8","v":0},{"$f":"$G$9*I8","v":0},0,null,"Wide",1076,1305,1748]
[null,null,null,null,null,"Loading %",null,null,null,null,null,"Comprehensive",1608,1960,2655]
[null,null,null,null,null,"Loaded Basic Premium",{"$f":"(G10*G11%)+G10","v":0},0,0,{"$f":"(J10*J11%)+J10","v":0}]
[null,null,null,null,null,"Sum of the Premium",{"$f":"SUM(G12:J12)","v":0}]
[null,null,null,null,null,"Discount %"]
[null,null,null,null,null,"Discounted Premium",{"$f":"G13-(G14%*G13)","v":0}]
[null,null,null,null,null,"Longterm Discount",{"$f":"IF(G9=1,0,IF(G9=2,8,IF(G9=3,15,0)))","v":0}]
[null,null,null,null,null,"Longterm Discounted Premium",{"$f":"G15-(G16%*G15)","v":0}]
[null,null,null,null,null,"Service Tax",{"$f":"12.36%*G17","v":0}]
[null,null,null,null,null,"Total Premium",{"$f":"G18+G17","v":0}]
[]
[]
[null,null,null,null,null,"Unit - Policy Level (when Total discount > Total Loading)",null,null,null,null,null,"Unit - Policy Level (when Total discount < Total Loading)"]
[]
[null,null,null,null,null,"Member",1,2,3,4,null,"Member",1,2,3,4]
[null,null,null,null,null,"Plan Type","Select",null,null,null,null,"Plan Type","Select"]
[null,null,null,null,null,"Risk Category","I","I","I","I",null,"Risk Category","I","I","I","I"]
[null,null,null,null,null,"Premium",null,null,null,null,null,"Premium"]
[null,null,null,null,null,"Policy Tenure",1,null,null,null,null,"Policy Tenure",1]
[null,null,null,null,null,"Basic Premium",{"$f":"$G$9*G27","v":0},{"$f":"$G$9*H27","v":0},{"$f":"$G$9*I27","v":0},0,null,"Basic Premium",{"$f":"$G$9*M27","v":0},{"$f":"$G$9*N27","v":0},{"$f":"$G$9*O27","v":0},0]
[null,null,null,null,null,"Sum of Premiums",null,null,null,null,null,"Sum of Premiums"]
[null,null,null,null,null,"Total Loading %",null,null,null,null,null,"Total Loading %"]
[null,null,null,null,null,"Total Discount %",null,null,null,null,null,"Total Discount %"]
[null,null,null,null,null,"Nulified",{"$f":"G32-G31","v":0},null,null,null,null,"Nulified",{"$f":"M31-M32","v":0}]
[null,null,null,null,null,"Discounted Premium",{"$f":"G30-(G33%*G30)","v":0},null,null,null,null,"Loaded Premium",{"$f":"M30+(M33%*M30)","v":0}]
[null,null,null,null,null,"Longterm Discount",{"$f":"IF(G28=1,0,IF(G28=2,8,IF(G28=3,15,0)))","v":0},null,null,null,null,"Longterm Discount",{"$f":"IF(M28=1,0,IF(M28=2,8,IF(M28=3,15,0)))","v":0}]
[null,null,null,null,null,"Longterm Discounted Premium",{"$f":"G34-(G35%*G34)","v":0},null,null,null,null,"Longterm Discounted Premium",{"$f":"M34-(M35%*M34)","v":0}]
[null,null,null,null,null,"Service Tax",{"$f":"12.36%*G36","v":0},null,null,null,null,"Service Tax",{"$f":"12.36%*M36","v":0}]
[null,null,null,null,null,"Total Premium",null,null,null,null,null,"Total Premium",{"$f":"M37+M36","v":0}]
[]
[]
[null,null,null,null,null,"Unit - Policy Level (when Total discount = Total Loading)"]
[]
[null,null,null,null,null,"Member",1,2,3,4]
[null,null,null,null,null,"Plan Type","Select"]
[null,null,null,null,null,"Risk Category","I","I","I","I"]
[null,null,null,null,null,"Premium"]
[null,null,null,null,null,"Policy Tenure",1]
[null,null,null,null,null,"Basic Premium",{"$f":"$G$9*G46","v":0},{"$f":"$G$9*H46","v":0},{"$f":"$G$9*I46","v":0},0]
[null,null,null,null,null,"Sum of Premiums",{"$f":"SUM(G48:J48)","v":0}]
[null,null,null,null,null,"Longterm Discount",{"$f":"IF(G47=1,0,IF(G47=2,8,IF(G47=3,15,0)))","v":0}]
[null,null,null,null,null,"Longterm Discounted Premium",{"$f":"G49-(G50%*G49)","v":0}]
[null,null,null,null,null,"Service Tax",{"$f":"12.36%*G51","v":0}]
[null,null,null,null,null,"Total Premium",{"$f":"G52+G51","v":0}]

{"sheet":"Dr Pankaj","index":3,"n_rows":61,"n_cols":15,"rows_kept":61,"cut":false,"hidden":true,"merged":[[47,8,47,9],[50,2,52,2],[50,3,52,3],[50,4,50,6],[51,4,52,4],[51,5,52,5],[51,6,52,6],[1,0,3,0],[1,4,1,9],[23,8,23,9],[29,8,29,9],[39,2,41,2],[39,3,41,3],[39,4,39,6],[40,4,41,4],[40,5,41,5],[40,6,41,6]]}
[]
["Net Premium (Flexi)\nwith Add on covers","Class I",2560,null,"Flexi-Expected Result"]
[null,"Class II",3099,null,"Cover Name","Units/Weeks","Sum Insured","Revised SI","Rate as per Annexure","Premium Amount",null,null,"Class I","Class II","Class III"]
[null,"Class III",4157.5,null,"Accidental Death (AD) ","NA",50000000,{"$f":"G4","v":50000000},{"$f":"M4","v":0.35},{"$f":"H4*I4/1000","v":17500},null,null,0.35,0.46,0.69]
[null,null,null,null,"Permanent Total Disability (PTD)","NA",50000000,{"$f":"G5","v":50000000},{"$f":"M5","v":0.18},{"$f":"H5*I5/1000","v":9000},null,null,0.18,0.23,0.31]
["Class I","Doctors, Lawyers",null,null,"Permanent Partial Disability (PPD)","NA",50000000,{"$f":"G6","v":50000000},0.23,{"$f":"H6*I6/1000","v":11500},null,null,0.23,0.28000000000000003,0.35]
["Class II","Sportsman",null,null,"Temporary Total Disability (TTD)",52,20000,{"$f":"F7*G7","v":1040000},0.38,{"$f":"H7*I7/1000","v":395.2},null,null,0.38,0.56999999999999995,0.95]
["Class III","Jockeys, Winter sports",null,null,"Accidental Hospitalization Expenses","NA",200000,{"$f":"G8","v":200000},0.14000000000000001,{"$f":"H8*I8/100","v":280.00000000000006},null,null,0.14000000000000001,0.14000000000000001,0.14000000000000001]
[null,null,null,null,"Accidental Hospital Daily Cash",3,500,{"$f":"F9*G9","v":1500},23,{"$f":"I9*F9","v":69},null,null,23,34,54]
[null,null,"will be per cent",null,"Child Education Support Benefit","NA",100000,{"$f":"G10","v":100000},0.54,{"$f":"H10*I10/1000","v":54},null,null,0.54,0.69,1]
[null,null,"Rate not present in Premium Extract",null,"Life Support Benefit",null,null,{"$f":"F11*G11","v":0},null,{"$f":"I11*F11","v":0},null,null,200,200,200]
[null,null,null,null,"Loan Protector",2,12000,{"$f":"F12*G12","v":24000},{"$f":"M12","v":250},{"$f":"I12*F12","v":500},null,null,250,250,250]
[null,null,null,null,"Broken Bone","NA",300000,{"$f":"G13","v":300000},0.38,{"$f":"H13*I13/1000","v":114},null,null,0.38,0.56999999999999995,0.95]
[null,null,null,null,"Modification of Vehicle/Residence","NA",null,0,null,{"$f":"H14*I14/1000","v":0},null,null,0.42,0.51,0.66]
[null,null,null,null,"Family Transport Benefit","NA",null,0,null,{"$f":"H15*I15/1000","v":0},null,null,0.3,0.39,0.6]
[null,null,null,null,"Outstanding Bills Protection Benefit","NA",null,0,null,{"$f":"H16*I16/100","v":0},null,null,0.28999999999999998,0.38,0.57999999999999996]
[null,null,null,null,"Ambulance Hiring Charges","NA",1500,1500,{"$f":"M17","v":25},{"$f":"I17","v":25},null,null,25,25,25]
[null,null,null,null,"Legal Bail Expenses","NA",5000,5000,80,{"$f":"I18","v":80},null,null,80,80,80]
[null,null,null,null,"Double Indemnity      ","NA",null,0,null,{"$f":"H19*I19/1000","v":0},null,null,0.09,0.12,0.18]
[null,null,null,null,"Total","NA",{"$f":"SUM(G4:G19)","v":150639000},{"$f":"SUM(H4:H19)","v":151672000},{"$f":"SUM(I4:I19)","v":380.2},{"$f":"SUM(J4:J19)","v":39517.199999999997}]
[null,null,null,null,null,null,null,null,"Total Premium",{"$f":"(J20*15%)+J20","v":45444.78},null,{"$f":"J20*3","v":118551.59999999999},"3 years"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L21*15%","v":17782.739999999998}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L21-L22","v":100768.85999999999}]
[null,null,null,null,null,null,null,null,"2 yr",null,null,{"$f":"L23*114.5%","v":115380.34469999999},54066,null,4996]
[null,null,null,null,null,null,null,null,null,{"$f":"J20","v":39517.199999999997},null,null,null,null,{"$f":"O24*155%","v":7743.8}]
[null,null,null,null,null,null,null,null,null,{"$f":"J25*2","v":79034.399999999994}]
[null,null,null,null,null,null,null,null,0.08,{"$f":"J26*I27","v":6322.7519999999995}]
[null,null,null,null,null,null,null,null,null,{"$f":"J26-J27","v":72711.648000000001}]
[]
[null,null,null,null,null,null,null,null,"3 yr"]
[null,null,null,null,null,null,null,null,null,{"$f":"J20","v":39517.199999999997}]
[null,null,null,null,null,null,null,null,null,{"$f":"J31*3","v":118551.59999999999}]
[null,null,null,null,null,null,null,null,0.15,{"$f":"J32*I33","v":17782.739999999998}]
[null,null,null,null,null,null,null,null,null,{"$f":"J32-J33","v":100768.85999999999}]
[]
[]
[]
[]
[]
[null,null,"Type of family","Loading on primary Insured premium","After Loading Net Premium (our Calculations)"]
[null,null,null,null,"Class I","Class II","Class II"]
[]
[null,null,"1+1 (Non – Earning)",0.2,{"$f":"($C$2*D43)+$C$2","v":3072},{"$f":"($C$3*D43)+$C$3","v":3718.8},{"$f":"($C$4*D43)+$C$4","v":4989}]
[null,null,"1+1 (Earning)",0.45,3712,4493.55,6028.375]
[null,null,"1+1 (Child)",7.0000000000000007E-2,2739.2,3315.93,4448.5249999999996]
[null,null,"1+2 (Non - Earning +Child)",0.3,3328,4028.7,5404.75]
[null,null,"1+2 (Earning + Child)",0.55000000000000004,3968,4803.45,6444.125]
[null,null,"1+2 (Children)",0.2,3072,3718.8,4989]
[null,null,"1+3 (Non - Earning +2 Children)",0.45,3712,4493.55,6028.375]
[null,null,"1+3 (Earning +2 Children)",0.66,4249.6000000000004,5144.34,6901.4500000000007]
[null,null,"Type of family","Loading on primary Insured premium","After Loading Net Premiums (System displaying)"]
[null,null,null,null,"Class I","Class II","Class II"]
[]
[null,null,"1+1 (Non – Earning)",0.2,3072,3718.8,4989]
[null,null,"1+1 (Earning)",0.45,3712,4493.55,6028.38]
[null,null,"1+1 (Child)",7.0000000000000007E-2,2739.2,3315.93,4448.5200000000004]
[null,null,"1+2 (Non - Earning +Child)",0.3,3328,4028.7,5404.75]
[null,null,"1+2 (Earning + Child)",0.55000000000000004,3968,4803.45,6444.13]
[null,null,"1+2 (Children)",0.2,3072,3718.8,4989]
[null,null,"1+3 (Non - Earning +2 Children)",0.45,3712,4493.55,6028.38]
[null,null,"1+3 (Earning +2 Children)",0.66,4249.6000000000004,5144.34,6901.45]

{"sheet":"ipa","index":4,"n_rows":61,"n_cols":42,"rows_kept":61,"cut":false,"hidden":false,"merged":[[1,0,3,0],[1,4,1,9],[23,8,23,9],[29,8,29,9],[39,2,41,2],[39,3,41,3],[39,4,39,6],[40,4,41,4],[40,5,41,5],[40,6,41,6],[1,12,1,14],[47,8,47,9],[50,2,52,2],[50,3,52,3],[50,4,50,6],[51,4,52,4],[51,5,52,5],[51,6,52,6]]}
[]
["Net Premium (Flexi)\nwith Add on covers","Class I",2560,null,"Flexi-Expected Result",null,null,null,null,null,null,null,"Premium rates per 1000 sum insured as per Risk category "]
[null,"Class II",3099,null,"Cover Name","Units/Weeks","Sum Insured","Sum Insured","Rate as per Annexure","Premium Amount",null,null,"Class I","Class II","Class III",null,null,"Plan","SI","SI","SI","SI","SI","SI","SI","SI","SI","SI","SI","SI","SI","SI","SI","SI","SI","SI","SI","SI"]
[null,"Class III",4157.5,null,"Accidental Death (AD) ","NA",0,500000,{"$f":"M4","v":0.35},{"$f":"H4*I4/1000","v":175},null,null,0.35,0.46,0.69,null,null,"Accidental Death (AD) ",100000,200000,300000,400000,500000,600000,700000,800000,900000,1000000,1100000,1200000,1300000,1400000,1500000,1600000,1700000,1800000,1900000,2000000,null,null,null,"Note- AD must be Higher than any other coverage"]
[null,null,null,null,"Permanent Total Disability (PTD)","NA",0,500000,{"$f":"M5","v":0.18},{"$f":"H5*I5/1000","v":90},null,null,0.18,0.23,0.31,null,null,"Permanent Total Disability (PTD)",100000,200000,300000,400000,500000,600000,700000,800000,900000,1000000,1100000,1200000,1300000,1400000,1500000,1600000,1700000,1800000,1900000,2000000,null,null,null,"PTD, PPD, TTD cannot be higher than AD "]
["Class I","Doctors, Lawyers",null,null,"Permanent Partial Disability (PPD)","NA",0,500000,0.23,{"$f":"H6*I6/1000","v":115},null,null,0.23,0.28000000000000003,0.35,null,null,"Permanent Partial Disability (PPD)",100000,200000,300000,400000,500000,600000,700000,800000,900000,1000000,1100000,1200000,1300000,1400000,1500000,1600000,1700000,1800000,1900000,2000000]
["Class II","Sportsman",null,null,"Temporary Total Disability (TTD)",52,0,500000,0.38,{"$f":"H7*I7/1000","v":190},null,null,0.38,0.56999999999999995,0.95,null,null,"Broken Bones",5000,"NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
["Class III","Jockeys, Winter sports",null,null,"Accidental Hospitalization Expenses","NA",0,{"$f":"G8","v":0},0.14000000000000001,{"$f":"H8*I8/100","v":0},null,null,0.14000000000000001,0.14000000000000001,0.14000000000000001,null,null,"Child Education  Benefit",10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000]
[null,null,null,null,"Accidental Hospital Daily Cash",0,0,0,23,{"$f":"I9*F9","v":0},null,null,23,34,54,null,null,"Performance Of Funreal Ceremony",10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000]
[null,null,"will be per cent",null,"Child Education Support Benefit","NA",0,{"$f":"G10","v":0},0.54,{"$f":"H10*I10/1000","v":0},null,null,0.54,0.69,1,null,null,"Transportaion Of Mortal Remains",10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000,10000]
[null,null,"Rate not present in Premium Extract",null,"Life Support Benefit",null,null,{"$f":"F11*G11","v":0},200,200,null,null,200,200,200]
[null,null,null,null,"Loan Protector",0,0,{"$f":"F12*G12","v":0},{"$f":"M12","v":250},{"$f":"I12*F12","v":0},null,null,250,250,250]
[null,null,null,null,"Broken Bone","NA",0,{"$f":"G13","v":0},0.38,{"$f":"H13*I13/1000","v":0},null,null,0.38,0.56999999999999995,0.95]
[null,null,null,null,"Modification of Vehicle/Residence","NA",null,0,null,{"$f":"H14*I14/1000","v":0},null,null,0.42,0.51,0.66]
[null,null,null,null,"Family Transport Benefit","NA",null,0,null,{"$f":"H15*I15/1000","v":0},null,null,0.3,0.39,0.6]
[null,null,null,null,"Outstanding Bills Protection Benefit","NA",null,0,null,{"$f":"H16*I16/100","v":0},null,null,0.28999999999999998,0.38,0.57999999999999996]
[null,null,null,null,"Ambulance Hiring Charges","NA",1500,1500,{"$f":"M17","v":25},{"$f":"I17","v":25},null,null,25,25,25]
[null,null,null,null,"Legal Bail Expenses","NA",5000,5000,80,{"$f":"I18","v":80},null,null,80,80,80]
[null,null,null,null,"Double Indemnity      ","NA",null,0,null,{"$f":"H19*I19/1000","v":0},null,null,0.09,0.12,0.18]
[null,null,null,null,"Total","NA",null,{"$f":"SUM(H4:H19)","v":2006500},null,{"$f":"SUM(J4:J19)","v":875}]
[null,null,null,null,null,null,null,null,"Total Premium",{"$f":"(J20*18%)+J20","v":1032.5}]
[]
[]
[null,null,null,null,null,null,null,null,"2 yr"]
[null,null,null,null,null,null,null,null,null,{"$f":"J20","v":875}]
[null,null,null,null,null,null,null,null,null,{"$f":"J25*2","v":1750}]
[null,null,null,null,null,null,null,null,0.08,{"$f":"J26*I27","v":140}]
[null,null,null,null,null,null,null,null,null,{"$f":"J26-J27","v":1610}]
[]
[null,null,null,null,null,null,null,null,"3 yr"]
[null,null,null,null,null,null,null,null,null,{"$f":"J20","v":875}]
[null,null,null,null,null,null,null,null,null,{"$f":"J31*3","v":2625}]
[null,null,null,null,null,null,null,null,0.15,{"$f":"J32*I33","v":393.75}]
[null,null,null,null,null,null,null,null,null,{"$f":"J32-J33","v":2231.25}]
[]
[]
[]
[]
[]
[null,null,"Type of family","Loading on primary Insured premium","After Loading Net Premium (our Calculations)"]
[null,null,null,null,"Class I","Class II","Class II"]
[]
[null,null,"1+1 (Non – Earning)",0.2,{"$f":"($C$2*D43)+$C$2","v":3072},{"$f":"($C$3*D43)+$C$3","v":3718.8},{"$f":"($C$4*D43)+$C$4","v":4989}]
[null,null,"1+1 (Earning)",0.45,3712,4493.55,6028.375]
[null,null,"1+1 (Child)",7.0000000000000007E-2,2739.2,3315.93,4448.5249999999996]
[null,null,"1+2 (Non - Earning +Child)",0.3,3328,4028.7,5404.75]
[null,null,"1+2 (Earning + Child)",0.55000000000000004,3968,4803.45,6444.125]
[null,null,"1+2 (Children)",0.2,3072,3718.8,4989]
[null,null,"1+3 (Non - Earning +2 Children)",0.45,3712,4493.55,6028.375]
[null,null,"1+3 (Earning +2 Children)",0.66,4249.6000000000004,5144.34,6901.4500000000007]
[null,null,"Type of family","Loading on primary Insured premium","After Loading Net Premiums (System displaying)"]
[null,null,null,null,"Class I","Class II","Class II"]
[]
[null,null,"1+1 (Non – Earning)",0.2,3072,3718.8,4989]
[null,null,"1+1 (Earning)",0.45,3712,4493.55,6028.38]
[null,null,"1+1 (Child)",7.0000000000000007E-2,2739.2,3315.93,4448.5200000000004]
[null,null,"1+2 (Non - Earning +Child)",0.3,3328,4028.7,5404.75]
[null,null,"1+2 (Earning + Child)",0.55000000000000004,3968,4803.45,6444.13]
[null,null,"1+2 (Children)",0.2,3072,3718.8,4989]
[null,null,"1+3 (Non - Earning +2 Children)",0.45,3712,4493.55,6028.38]
[null,null,"1+3 (Earning +2 Children)",0.66,4249.6000000000004,5144.34,6901.45]

{"sheet":"Summary","index":5,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["Coverage","G Satyanarayana","Mrs Goli"]
["AD",10000000,8000000]
["PTD","As per table","As per table"]
["PPD","As per table","As per table"]
["TTD","20000 per week for max 52 weeks","20000 per week for max 52 weeks"]
["Child Education Benefit",10000,10000]
["Cost of Transporting Mortal Remains",10000,10000]
["Cost of Performance of Death Ceremony",10000,10000]
["Child Education Support Benefit",100000,100000]
["Accidental Hospitalization Expenses",200000,200000]
["Accidental Hospital Daily Cash","1,500 per day for max 30 days","1,500 per day for max 30 days"]
["Loan Protector","24,000 per month for max 12 months","24,000 per month for max 12 months"]
["Broken Bone",300000,300000]
["Ambulance Hiring Charges",1500,1500]
["Legal Bail Expenses",5000,5000]
["Double Indemnity","100% CSI","100% CSI"]
["Premium without tax for 1 year",10017,8250]
["Premium without tax for 3 year",{"$f":"B17*3","v":30051},{"$f":"C17*3","v":24750}]
[null,{"$f":"B18+C18","v":54801}]
["Family discount 5%",{"$f":"B19*95%","v":52060.95}]
["Long term discount 15%",{"$f":"B20*85%","v":44251.807499999995}]
["Final Premium with tax 14.5% for 3 year",50668]